{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":142,"n_cols":15,"rows_kept":142,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,4,4,5],[4,13,4,14],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,5,6,5],[5,6,6,6],[5,7,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,14],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,7,5],[7,6,8,6],[7,7,7,10],[7,11,7,14],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[16,4,16,5],[16,13,16,14],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,5,18,5],[17,6,18,6],[17,7,18,8],[17,9,18,9],[17,10,18,10],[17,11,18,11],[17,12,18,12],[17,13,18,14],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,19,5],[19,6,20,6],[19,7,19,10],[19,11,19,14],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[26,9,27,9],[26,10,27,10],[26,11,27,11],[26,12,27,12],[26,13,27,13],[26,14,27,14],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[32,2,33,2],[32,3,32,5],[32,6,33,6],[32,7,32,10],[32,11,32,14],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,6],[39,7,40,7],[39,8,40,8],[39,9,40,9],[39,10,40,10],[39,11,40,11],[39,12,40,12],[39,13,40,13],[39,14,40,14],[42,0,43,0],[42,1,43,1],[44,0,45,0],[44,1,45,1],[44,2,45,2],[44,3,44,5],[44,6,45,6],[44,7,44,10],[44,11,44,14],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,6],[51,7,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[51,11,52,11],[51,12,52,12],[51,13,52,13],[51,14,52,14],[54,0,55,0],[54,1,55,1],[56,0,57,0],[56,1,57,1],[56,2,57,2],[56,3,56,5],[56,6,57,6],[56,7,56,10],[56,11,56,14],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,6,63,6],[62,7,63,7],[62,8,63,8],[62,9,63,9],[62,10,63,10],[62,11,63,11],[62,12,63,12],[62,13,63,13],[62,14,63,14],[65,0,66,0],[65,1,66,1],[67,0,68,0],[67,1,68,1],[67,2,68,2],[67,3,67,5],[67,6,68,6],[67,7,67,10],[67,11,67,14],[75,2,76,2],[75,3,76,3],[75,4,76,4],[75,5,76,5],[75,6,76,6],[75,7,76,7],[75,8,76,8],[75,9,76,9],[75,10,76,10],[75,11,76,11],[75,12,76,12],[75,13,76,13],[75,14,76,14],[78,0,79,0],[78,1,79,1],[80,0,81,0],[80,1,81,1],[80,2,81,2],[80,3,80,5],[80,6,81,6],[80,7,80,10],[80,11,80,14],[87,2,88,2],[87,3,88,3],[87,4,88,4],[87,5,88,5],[87,6,88,6],[87,7,88,7],[87,8,88,8],[87,9,88,9],[87,10,88,10],[87,11,88,11],[87,12,88,12],[87,13,88,13],[87,14,88,14],[91,0,92,0],[91,1,92,1],[91,2,92,2],[91,3,91,5],[91,6,92,6],[91,7,91,10],[91,11,91,14],[98,2,99,2],[98,3,99,3],[98,4,99,4],[98,5,99,5],[98,6,99,6],[98,7,99,7],[98,8,99,8],[98,9,99,9],[98,10,99,10],[98,11,99,11],[98,12,99,12],[98,13,99,13],[98,14,99,14],[103,0,104,0],[103,1,104,1],[103,2,104,2],[103,3,103,5],[103,6,104,6],[103,7,103,10],[103,11,103,14],[114,0,115,0],[114,1,115,1],[114,2,115,2],[114,3,114,5],[114,6,115,6],[114,7,114,10],[114,11,114,14],[123,0,123,4],[124,1,126,3],[124,4,127,4],[140,0,141,0],[140,2,141,2],[140,3,141,3],[140,4,141,4],[143,0,143,1]]}
["Примерное меню завтраков для обучающихся 1-4-х классов                                                                          "]
["Основание:  "]
["1. Санитарно-эпидемиологические правила и нормы СанПиН 2,3/2,4,3590-20, Утверждены постановлением Главного государственного санитарного врача Российской Федерации от 27 октября 2020г. №32"]
["2.  Сборник рецептур на продукцию для обучающихся во всех образовательных учреждениях.                                                                                                                      Под ред. М.П.Могильного и  В.А.Тутельяна. - М.:ДеЛи плюс,2015 и 2017 года                                                                                                                                                                                                                                                                           "]
["День:","первый"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[401,"Оладьи ",105,7.42,7.86,36.5,282.85,null,1.76,null,null,33.38,2.7,49.77,2.5]
[null,"с повидлом",45,0,0,29.25,117,0.3,0.27,null,null,0.63,0.5,0.81,3.24]
[377,"Чай с сахаром и лимоном 195/5",200,0.13,0.02,9.9,29.5,null,2.8,null,0.01,14.9,4.3,2.3,0.34]
[338,"Фрукты (яблоки)",170,0.68,0.68,16.66,79.9,0.01,39.79,57.8,0.42,62.9,34,20.4,0.34]
[null,"соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C10:C13)","v":520},8.23,8.56,92.31,509.25,0.31,44.62,57.8,0.43,111.81,41.5,73.28,6.42]
[]
["День:  ","второй"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[175,"Каша «Дружба» молочная с маслом слив. (рис, пшено) ",250,7.6,12.25,39.15,296.87,0.1,0.8,20.9,"-",17.1,180.6,38.6,0.75]
[382,"Какао с молоком ",200,4.08,3.54,17.58,118.6,0.05,1.3,24.4,null,133.2,124.5,25.5,2]
["б/н","батон нарезной",30,2.25,0.84,15.51,85.8,0.3,"-","-",0.39,6.9,26.1,9.9,0.33]
[338,"Фрукты (яблоки)",100,0.4,0.4,9.8,47,0.01,16.9,23.8,0.2,25.9,14,8.4,0.14]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C22:C25)","v":580},14.33,17.029999999999998,82.03999999999999,548.27,{"$f":"SUM(H22:H25)","v":0.46},{"$f":"SUM(I22:I25)","v":19},69.1,0.5900000000000001,183.1,345.20000000000005,82.4,3.22]
[]
[]
["День:  ","третий"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[259,"Жаркое по-домашнему (свинина нежирных сортов)",250,17.6,42.1,23.6,547.1,0.5,9.62,null,4.37,41,207.37,6,3.4]
[376,"Чай с сахаром  ",200,0.1,0.02,7,28.6,"-",1.6,"-",null,11.1,2.8,1.4,0.03]
["б/н","Хлеб ржаной",40,1.87,0.63,10.7,56,0.05,"-","-",0.48,12.26,56.53,13.33,1.65]
[null,"Шоколад",15,1.05,5.1,7.5,82.5]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C35:C38)","v":505},20.620000000000005,47.85000000000001,48.8,714.2,0.55,11.219999999999999,0,4.85,64.36,266.70000000000005,20.73,5.08]
[]
["День:  ","четвертый"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р",null,"Fe"]
[174,"Каша рисовая молочная с маслом сливочным",200,15.48,27.58,45.58,321.83,0.06,0.96,54.8,null,85.36,157.4,36.48,0.6]
[376,"Чай с сахаром и лимоном",200,0.13,0.02,9.9,29.5,null,2.8,null,0.01,14.9,4.3,2.3,0.34]
["б/н","Батон нарезной",40,3,1.16,20.36,105.6,0.57,null,null,0.52,9.25,34.85,11.6,0.39]
[338,"Фрукты (яблоки)",150,0.6,0.6,14.7,70.5,0.03,15,null,0.3,24,16.5,13.5,3.3]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C47:C50)","v":590},19.21,29.36,90.54,527.43,{"$f":"SUM(H47:H50)","v":0.6599999999999999},{"$f":"SUM(I47:I50)","v":18.759999999999998},54.8,0.8300000000000001,133.51,213.05,63.879999999999995,4.63]
[]
["День:  ","пятый"]
["Неделя: ","первая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[398,"Блинчики с фруктовой начинкой  с соусом из свежезамороженных ягод 180/30",210,{"v":5.9,"d":"5.90"},8.09,{"v":121.3,"d":"121.30"},{"v":558.7,"d":"558.70"},{"v":0.1,"d":"0.10"},{"v":16.1,"d":"16.10"},{"v":63,"d":"63.00"},null,{"v":41.3,"d":"41.30"},{"v":80.2,"d":"80.20"},{"v":30.4,"d":"30.40"},{"v":2.2,"d":"2.20"}]
[376,"Чай с сахаром  ",200,{"v":0.1,"d":"0.10"},0.02,{"v":7,"d":"7.00"},{"v":28.6,"d":"28.60"},null,{"v":1.6,"d":"1.60"},null,null,{"v":11.1,"d":"11.10"},{"v":2.8,"d":"2.80"},{"v":1.4,"d":"1.40"},0.03]
["б/н","Фрукты (яблоки)",100,0.4,0.4,9.8,47,0.02,10,"-",0.2,16,11,9,2.2]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C59:C61)","v":{"v":510,"d":"510.00"}},{"v":6.4,"d":"6.40"},8.51,{"v":138.10000000000002,"d":"138.10"},{"v":634.3000000000001,"d":"634.30"},{"v":0.12000000000000001,"d":"0.12"},{"v":27.700000000000003,"d":"27.70"},{"v":63,"d":"63.00"},{"v":0.2,"d":"0.20"},{"v":68.4,"d":"68.40"},{"v":94,"d":"94.00"},{"v":40.8,"d":"40.80"},4.43]
[]
["День:  ","шестой"]
["Неделя: ","вторая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[173,"Каша вязкая молочная пшенная с маслом сливочным",250,8.62,13.25,76.96,426.12,0.19,null,6.25,0.15,5.09,163.79,56.3,3.15]
[377,"Чай с сахаром и лимоном 195/5",200,0.13,0.02,9.9,29.5,null,2.8,null,0.01,14.9,4.3,2.3,0.34]
["б/н","батон нарезной",40,3,1.12,20.68,114.4,0.57,null,null,0.52,9.25,34.85,11.6,0.39]
[15,"сыр",15,3.48,4.42,null,54,0.01,0.11,56.52,0.1,191.3,108.7,7.6,0.2]
[null,"Хлеб ржаной ",30,1.4,0.47,7.8,42,0.04,null,null,0.36,9.2,42.4,10,1.24]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C70:C74)","v":535},16.63,19.28,115.33999999999999,666.02,{"$f":"SUM(H70:H74)","v":0.81},{"$f":"SUM(I70:I74)","v":2.9099999999999997},62.77,1.1400000000000001,229.74,354.03999999999996,87.79999999999998,5.32]
[]
["День:  ","седьмой"]
["Неделя: ","вторая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[243,"Сосиски отварные  для детского питания",100,10.4,23.9,0.4,260.5,{"$nulls":3},0.6,19.2,98.6,5.6,1.2]
["202 (309)","Макароны отварные с маслом сливочным",165,6.05,4.95,29.04,185.24,0.1,null,null,1.09,5.28,40.92,23.21,1.19]
[377,"Чай с сахаром и лимоном 195/5",200,0.13,0.02,9.9,29.5,null,2.8,null,0.01,14.9,4.3,2.3,0.34]
[null,"Хлеб ржаной",35,0.6,0.5,9.1,49,0.04,null,null,0.42,10.73,49.46,11.6,1.4]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C83:C86)","v":500},17.18,29.369999999999997,48.44,524.24,{"$f":"SUM(H83:H86)","v":0.14},{"$f":"SUM(I83:I86)","v":2.8},0,2.12,50.11,193.28,42.71,4.129999999999999]
[]
["День ","восьмой"]
["неделя ","вторая"]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[175,"Каша «Дружба» молочная с маслом слив. (рис, пшено) ",250,7.6,12.25,39.15,296.87,0.1,0.8,20.9,"-",17.1,180.6,38.6,0.75]
[382,"Какао с молоком ",200,4.08,3.54,17.58,118.6,0.05,1.3,24.4,null,133.2,124.5,25.5,2]
["б/н","батон нарезной",30,2.25,0.84,15.51,85.8,0.3,"-","-",0.39,6.9,26.1,9.9,0.33]
[338,"Фрукты (яблоки)",100,0.28,0.28,8.4,37.1,0.01,16.9,23.8,0.2,25.9,14,8.4,0.14]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C94:C97)","v":580},14.209999999999999,16.91,80.64,538.37,{"$f":"SUM(H94:H97)","v":0.46},{"$f":"SUM(I94:I97)","v":19},69.1,0.5900000000000001,183.1,345.20000000000005,82.4,3.22]
[]
["День ","девятый"]
["неделя ","вторая"]
[]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[401,"Оладьи ",105,7.42,7.86,36.5,282.85,null,1.76,null,null,33.38,2.7,49.77,2.5]
[null,"с повидлом",45,0,0,29.25,117,0.3,0.27,null,null,0.63,0.5,0.81,3.24]
[379,"Чай с сахаром",200,0.1,0.02,7,28.6,null,1.6,null,null,11.1,2.8,1.4,0.03]
[338,"Фрукты",170,0.68,0.68,16.66,79.9,0.01,39.79,57.8,0.42,62.9,34,20.4,0.34]
[null,"Шоколад",15,1.05,5.1,7.5,82.5]
["ИТОГО:",null,{"$f":"SUM(C106:C109)","v":520},8.2,8.56,89.41,508.35,{"$f":"SUM(H106:H109)","v":0.31},{"$f":"SUM(I106:I109)","v":43.42},57.8,0.42,108.01,40,72.38,6.11]
[]
["День","десятый"]
["Неделя ","вторая"]
["№ рецептуры","Приём пищи, наименование блюда","Масса порции (г)","Пищевые вещества (г.)",null,null,"Энергетическая ценность (ккал)","Витамины (мг.)",{"$nulls":3},"Минеральные вещества (мг.)"]
[{"$nulls":3},"Б","Ж","У",null,"В1","С","А","Е","Са","Р","Мg","Fe"]
[174,"Каша рисовая молочная с маслом сливочным",250,7.5,13.6,53.7,367.5,0.075,1.2,68.5,null,160.7,196.75,45.6,0.75]
[382,"Какао с молоком",180,3.67,3.18,15.82,106.74,0.04,1.17,21.96,null,119.88,112.05,22.95,1.8]
["б/н","Батон нарезной",40,3,1.12,20.68,114.4,0.57,null,null,0.52,9.25,34.85,11.6,0.39]
[null,"Фрукты (яблоки)",100,0.28,0.28,8.4,37.1,0.01,16.9,23.8,0.2,25.9,14,8.4,0.14]
[null,"Соль йодированная",1]
["ИТОГО:",null,{"$f":"SUM(C117:C120)","v":570},14.45,18.180000000000003,98.60000000000002,625.74,0.695,19.27,114.26,0.72,315.72999999999996,357.65000000000003,88.55,3.08]
[]
["Основные показатели в пищевых веществах и энергетической ценности   (к СанПиН 2.3/2.4.3590-20)"]
["                Основные показатели","Пищевые вещества (г)",null,null,"Энергетическая ценность (ккал)"]
[]
[" Дни по меню"]
[null,"Б","Ж","У"]
["1 день",8.23,8.56,92.31,509.25]
["2 день",14.33,17.029999999999998,82.03999999999999,548.27]
["3 день",20.620000000000005,47.85000000000001,48.8,714.2]
["4 день",19.21,29.36,90.54,527.43]
["5 день",6.4,8.51,138.10000000000002,634.3000000000001]
["6 день",16.63,19.28,115.33999999999999,666.02]
["7 день",17.18,29.369999999999997,48.44,524.24]
["8 день",14.209999999999999,16.91,80.64,538.37]
["9 день",8.2,8.56,89.41,508.35]
["10 день",14.45,18.180000000000003,98.60000000000002,625.74]
["Итого за весь период:",{"$f":"SUM(B129:B138)","v":139.45999999999998},{"$f":"SUM(C129:C138)","v":203.61},884.2199999999999,5796.17]
["Итого в среднем за 1день (прием пищи):",{"$f":"SUM(B139/10)","v":13.945999999999998},{"$f":"SUM(C139/10)","v":20.361},88.422,579.617]
["Завтрак – 20-25% от нормы","20-25% -  от нормы                - 77.00, составит ","20-25% -  от нормы                - 79.00, составит                15.80 – 19.75 "," 20-25% -  от нормы                - 335.00, составит               67.00 – 83.75","20-25% -  от нормы                                                          - 2350.00, составит                                                                               470.00 – 587.50"]
[null,"15.40 – 19.25  "]

{"sheet":"Лист2","index":1,"n_rows":28,"n_cols":1,"rows_kept":28,"merged":[[5,0,6,0],[20,0,21,0],[27,0,28,0]]}
[2.4]
[0.2]
[0.34]
[2.2]
[]
[{"$f":"SUM(A1:A4)","v":5.140000000000001}]
[]
[]
[]
[0.75]
[2]
[0.33]
[0.2]
[]
[]
[2.5]
[1.8]
[0.33]
[0.2]
[]
[4.83]
[]
[]
[1.8]
[0.03]
[2.9]
[]
[4.73]